xp-dev.com Git - namibia/blob - data/old_b4c stuff/templates_highest-price-guide.sql

   1 INSERT INTO `mig_db`.`lib_template` (`id`, `name`, `subject`, `tags`, `email_template`, `sms_template`)
   2 VALUES ('28',
   3 'highest-price-guide',
   4 'Confirmation of Highest Offer on Price Guide',
   5 'firstName,familyName,highest_offer_amount,Dealership_Name,year,make,model,Trade,Retail,registration_number',
   6 '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   7     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   8 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
   9 <head>
  10         <meta http-equiv="Content-type" content="text/html; charset=utf-8" />
  11         <title></title>
  12 </head>
  13 <body style="padding:0;margin:0;">
  14         <!-- Begin 100% Wrapping Table -->
  15         <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">
  16                 <tr>
  17                         <td style="padding:20px 0;">
  18                                 <!-- Begin Main Template Table -->
  19                                 <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">
  20                                         <tr>
  21                                                 <td>
  22                                                 <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />
  23                                                 </td>
  24                                         </tr>
  25                                         <tr>
  26                                                 <td style="background:#f6f6f6;padding:20px 0">
  27                                                         <!-- Main Content table -->
  28                                                         <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">
  29                                                                 <tr>
  30                                                                         <!-- Spacing Column -->
  31                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;</td>
  32                                                                         <!-- Main Column -->
  33                                                                         <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">
  34                                                                                 <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Confirmation of Highest Offer on Price Guide</h1>
  35                                                                                 <p style="margin:0 0 1em;padding:0;">
  36                                                                                         &nbsp;
  37                                                                                 </p>
  38                                                                                 <p style="margin:0 0 1em;padding:0;">
  39                                                                                         Dear [firstName] [familyName],
  40                                                                                 </p>
  41                                                                                 <p style="margin:0 0 1em;padding:0;">
  42                                                                                         We would like to inform you that you made a highest offer of: <br>
  43                                                                                         [highest_offer_amount] on the following vehicle listed by [Dealership_Name]:
  44                                                                                 </p>
  45
  46                                                                                 <div style="float:left; width:100%">
  47                                                                                         <div style="display: block; float: left; width: 165px;">
  48                                                                                         Vehicle:
  49                                                                                         </div>
  50                                                                                         <div style="float:left; display:block">
  51                                                                                         <p style="float:left; width:100%; display:block; font-size:15px; margin: 0; padding: 0;">
  52                                                                                         <strong>[year], [make], [model]</strong>
  53                                                                                         </p>
  54                                                                                         <p style="float:left; width:100%; display:block; margin:0">
  55                                                                                         [Trade], [Retail]
  56                                                                                         </p>
  57                                                                                         </div>
  58                                                                                 </div>
  59                                                                                 <div style="float:left; width:100%">
  60                                                                                 <br><br>
  61                                                                                 </div>
  62                                                                                 <div style="float:left; width:100%">
  63                                                                                         <div style="float:left; width:250px; display:block">
  64                                                                                         Registration Number:
  65                                                                                         </div>
  66                                                                                         <div style="float:left; display:block">
  67                                                                                         <p style="float:left; width:100%; display:block; margin:0">
  68                                                                                         [registration_number]
  69                                                                                         </p>
  70                                                                                         </div>
  71                                                                                 </div>
  72                                                                                 <div style="float:left; width:100%">
  73                                                                                 <br><br>
  74                                                                                 </div>
  75                                                                                 <div style="float:left; width:100%; font-size:15px; font-weight:bold ">
  76                                                                                         You will be notified via email should the deal be completed within the next 30 days.
  77                                                                                 </div>
  78
  79                                                                         </td>
  80                                                                         <!-- Spacing Column -->
  81                                                                         <td width="40" valign="top" style="width:40px;">&nbsp;</td>
  82                                                                         <!-- Side Column -->
  83                                                                         <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">
  84                                                                                 <img src="{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />
  85                                                                                 <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Bid4Cars</h2>
  86                                                                                 <p style="margin:0 0 1em;padding:5px;">
  87                                                                                         Online technology bringing buyers and sellers
  88                                                                                         together through the Dealer Network.
  89                                                                                 </p>
  90                                                                         </td>
  91                                                                         <!-- Spacing Column -->
  92                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;</td>
  93                                                                 </tr>
  94                                                         </table>
  95                                                         <!-- /Main Content Table -->
  96                                                 </td>
  97                                         </tr>
  98                                         <tr>
  99                                                 <td style="background:#ececec;padding:10px 0 0;">
 100                                                         <!-- Begin Footer table -->
 101                                                         <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">
 102                                                                 <tr>
 103                                                                         <!-- Spacing Column -->
 104                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;</td>
 105                                                                         <!-- Main Column -->
 106                                                                         <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">
 107                                                                                 <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>
 108                                                                         </td>
 109                                                                         <!-- Spacing Column -->
 110                                                                         <td width="380" valign="top" align="right" style="width:380px;">
 111                                                                                 Click <a href="{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.
 112                                                                         </td>
 113                                                                         <!-- Spacing Column -->
 114                                                                         <td width="20" valign="top" style="width:20px;">&nbsp;</td>
 115                                                                 </tr>
 116                                                         </table>
 117                                                         <!-- /End Footer Table -->
 118                                                 </td>
 119                                         </tr>
 120                                 </table>
 121                                 <!-- /End Main Template Table -->
 122                         </td>
 123                 </tr>
 124         </table>
 125 <!-- /End 100% Wrapping Table  -->
 126 </body>
 127 </html>'
 128 , ' ');